Configuring Monitoring

SequeLink provides the following levels of monitoring for SequeLink data access services, listed here from highest-level to lowest-level. Some of the monitoring levels are also supported for the SequeLink Agent service.

Service monitoring monitors these activities by service:
Statistics of received packets and sent packets
Sessions started and statements opened
Active statements and sessions
Fetched rows and affected rows
Transactions
Session monitoring monitors these activities by session within a service:
Statistics of received packets and sent packets
Statements opened and active statements
Fetched rows and affected rows
Transactions
Information about each session, such as start time, client information (network address, data source used by the client, and type of client), native database session identification, and database user
Statement monitoring monitors these activities by statement within a session:
Fetched rows and affected rows
SQL statements issued

To enable monitoring at one of the listed levels, higher-level monitoring must be enabled. For example, you cannot monitor Session information unless Service monitoring is enabled. Similarly, you cannot monitor Statement information unless both Service monitoring and Session monitoring are enabled.

On Linux/UNIX, both a monitoring and an event trace profile are enabled when you install SequeLink Server.

After installation, you can create a monitoring profile or modify an existing profile.

NOTES:

You can configure only one monitoring profile for each SequeLink service.
After changing the connection model for a service, you must delete any monitoring or event profiles for the service. For example, if you changed the connection model from Threadpool to Threadconnection, you must delete the monitoring and event profiles, and create new profiles.

You can integrate SequeLink monitoring with the Windows Performance Monitor tool, which allows you to access monitoring information from the Windows tool.

Creating a Monitoring Profile

Select the Profiles node for a SequeLink service (beneath the Configuration node). Select Action / New / Monitoring Profile. The Monitoring Properties window appears.







For Windows users: When you create a profile, the Enable Performance Monitoring window appears before the Monitoring window if you have the Windows Performance Monitor tool installed on the same Windows server on which the SequeLink Server and SequeLink Manager Snap-In are installed.

If you want to integrate SequeLink monitoring with the Windows Performance Monitor tool, select the Enable check box. Then, click Next. The Monitoring Properties window appears.

See "Integrating SequeLink® Monitoring with the Windows Performance Tool" for instructions on integrating SequeLink with the Windows Performance Tool.

Perform any of the following actions in the Monitoring window:
To enable a type of monitoring (Service Monitoring, Session Monitoring, and Statement Monitoring), select the Enable check box within the appropriate Monitoring group. Remember that to enable monitoring information at a monitoring level, you must enable the higher-level monitoring. Therefore, if you disable Service Monitoring, all lower-level monitoring information is also disabled.
To enable a property, select the check box beside the property.
To disable types of monitoring (Service Monitoring, Session Monitoring, and Statement Monitoring), clear the Enable check box within the appropriate Monitoring group.
To disable any property, clear the check box beside the property.
Click OK.
Restart the SequeLink service to activate the new monitoring profile.

Changing an Existing Monitoring Profile

Select the Profiles node for a SequeLink service (beneath the service's Configuration node). The monitoring profile is displayed in the Details pane. Double-click the monitoring profile. The Monitoring Properties window appears.





Perform any of the following actions in the Monitoring window:
To enable a type of monitoring (Service Monitoring, Session Monitoring, and Statement Monitoring), select the Enable check box within the appropriate Monitoring group. Remember that to enable monitoring information at a monitoring level, you must enable the higher-level monitoring. Therefore, if you disable Service Monitoring, all lower-level monitoring information is also disabled.
To enable a property, select the check box beside the property.
To disable types of monitoring (Service Monitoring, Session Monitoring, and Statement Monitoring), clear the Enable check box within the appropriate Monitoring group.
To disable a property, clear the check box beside the property.
Click OK.
Restart the SequeLink service to activate the changed monitoring profile.

Deleting a Monitoring Profile

Select the Profiles node for a SequeLink service (beneath the service's Configuration node). The existing monitoring profile is displayed in the Details pane.
Right-click the monitoring profile, and select Delete.
You are prompted to confirm the deletion. Click OK to confirm. The profile is deleted from the service configuration.
Save the configuration.

Integrating SequeLink^® Monitoring with the Windows Performance Tool

If you are integrating SequeLink monitoring with the Windows Performance Monitoring tool on the Windows platforms on which the SequeLink Server runs, you must explicitly set the required counters in the Windows registry. When the SequeLink Server installation finishes, the files SWEVPERF.INI and SWEVPERF.H appear in your temporary directory (for example, C:\temp).

To integrate SequeLink monitoring with Windows performance monitoring:

Using a command prompt, change the directory to the directory containing the SWEVPERF.INI file (for example, C:\temp).
Type the following command; then, press ENTER:

lodctr swevperf.ini

If you do not have an active (enabled) monitoring profile that is configured for integration with the Windows Performance Monitor tool, configure one. See "Configuring Monitoring" for instructions on configuring monitoring. To activate a new monitoring profile, restart the SequeLink service for which you defined the profile.

NOTE: If you have a monitoring profile that is not configured for integration with the Windows Performance Monitor Tool, delete that monitoring profile and create one that is configured for integration. Integration must be configured when you create the profile.

Start the Windows Performance Monitor tool and select the Add to Chart menu item. In the window that appears, select the SequeLink 6.0 Services object and select the counters you want to monitor from the Instance list box.